﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SQLite;
using System.IO;
using System.Data.Common;

namespace SQLiteDataConverter
{
    class Program
    {
        static void Main(string[] args)
        {

            CreateSQLiteDBForPostalCode();
            CreateSQLiteDBForIFSC();

        }

        private static void CreateSQLiteDBForPostalCode()
        {
            //string dbPath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "PostalCode.db3");
            //try
            //{
            //    SQLiteFactory factory = (SQLiteFactory)DbProviderFactories.GetFactory("System.Data.SQLite");
            //    using (SQLiteConnection connection = (SQLiteConnection)factory.CreateConnection())
            //    {
            //        connection.ConnectionString = string.Format("Data Source={0};Version=3;New=False;Compress=True;", dbPath);
            //        connection.Open();
            //        Console.WriteLine("Connection opened..");
            //        using (SQLiteCommand command = new SQLiteCommand(connection))
            //        {
            //            command.CommandText = @"SELECT * FROM Contact;";
            //            var reader = command.ExecuteReader();

            //            while (reader.Read())
            //            {
                          
                            
            //            }
            //            Console.WriteLine("Done! Press eny Key to continue.");
            //        }
            //    }

            //    return contacts;
            //}
            //catch (Exception ex)
            //{
            //    Console.WriteLine("OOPS:" + ex.Message);
            //    return null;
            //}
            //finally
            //{
            //    /// if (writer != null)
            //    //  writer.Close();
            //}
        }

        private static void CreateSQLiteDBForIFSC()
        {
            throw new NotImplementedException();
        }
    }
}
